Nick Korna
Nick Korna
Reactions
-
Re: Countifs With Multiple Criteria
If you're just wanting a count of how many times clients A or B appear on a sheet, then it would be: =COUNTIF({Client}, OR(@cell = "A", @cell = "B")) You can add in extra ones by …1 · -
Re: Unsure of formula or function to pull sales agent data from 2nd sheet
If your 2023 Sales data is in a column of the same name and on the same row then your formula would be: =IF(MATCH([Agent Full Name]@row, {2024 IBG Agent Sales Activity Range 2})>0,SUMIF({2024 IBG …1 · -
Re: CountIF Has Multi Select Count
@ajk1317, here you would switch from using COUNTIF to using COUNTIFS as you have multiple criteria. The formula would be very similar, just with an added S (bolded): =COUNTIFS({goals}, HAS(@cell, &qu…1 · -
Re: Multiple IF ERROR in a single formula
Hi @trey.bowman, Your IFERRORs need to be nested slightly differently: =IFERROR(IFERROR(VLOOKUP([Row ID]@row, {RANGE1}, 22, false),VLOOKUP([Row ID]@row, {RANGE21}, 24, false)),VLOOKUP([Row ID]@row, {…1 · -
Re: CountIF Has Multi Select Count
Hi @ajk1317, The @cell is what you would want to use here: =COUNTIF({goals}, HAS(@cell, "Doesn't Matter, Get Better")) This would count the cells in the Goals column where a cell has "…1 ·
